package com.yunze.common.mapper.mysql.newcard.card;

import com.alibaba.fastjson.JSONObject;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface YzNewCardMapper {

    List<Map<String, Object>> selDLL(Map<String,Object> map);

    List<Map<String,Object>> selcard(JSONObject jsonObject);

    int selById(@Param("iccid") String iccid);

    Integer Count(JSONObject jsonObject);

    void updateUsage(Map<String, Object> objectObjectHashMap);

    Map<String,Object> findByRouter(String params);

    void updateStatus(Map<String, Object> objectMap);

    List<Map<String,Object>> queryReceiveSms(JSONObject jsonObject);

    Integer queryReceiveSmsCount(JSONObject jsonObject);
}
